# This file is to assign each county a different number in alphabetical order.

BEGIN {
  FS = ","
  OFS = ","
  print "County Code", "RRC", "County", "Year", "Employment", "# Wells", "Gas", "Oil", "Others" 

}

{
  if (NR % 11 == 0) 
    county_code = int(NR/11);
  else
    county_code = int(NR/11)+1;

  print county_code, $0

}



